/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : bluesky

 Target Server Type    : MySQL
 Target Server Version : 50734
 File Encoding         : 65001

 Date: 13/07/2021 00:13:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `config_name` varchar(128) NULL DEFAULT NULL COMMENT '参数名称',
  `config_key` varchar(128) NULL DEFAULT NULL COMMENT '参数键名',
  `config_value` varchar(512) NULL DEFAULT NULL COMMENT '参数键值',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `status` varchar(1) NULL DEFAULT '0' COMMENT '状态 0正常；1停用',
  `created_by` varchar(32) NULL DEFAULT NULL COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(32) NULL DEFAULT NULL COMMENT '更新人',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '系统参数';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1407569388382302209, '账号初始密码', 'sys_init_password', '123456', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父部门ID',
  `dept_name` varchar(32) NULL DEFAULT NULL COMMENT '部门名称',
  `dept_fullname` varchar(128) NULL DEFAULT NULL COMMENT '部门全名',
  `ancestors` varchar(1024) NULL DEFAULT NULL COMMENT '祖级列表',
  `org_type` varchar(1) NULL DEFAULT NULL COMMENT '机构类型 1公司；2部门；3小组；4其他',
  `leader` varchar(32) NULL DEFAULT NULL COMMENT '负责人',
  `leader_phone` varchar(32) NULL DEFAULT NULL COMMENT '负责人电话',
  `phone` varchar(32) NULL DEFAULT NULL COMMENT '办公电话',
  `email` varchar(128) NULL DEFAULT NULL COMMENT '邮箱',
  `post_code` varchar(32) NULL DEFAULT NULL COMMENT '邮政编码',
  `address` varchar(512) NULL DEFAULT NULL COMMENT '联系地址',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `status` varchar(1) NULL DEFAULT '0' COMMENT '状态 0正常；1停用',
  `created_by` varchar(32) NULL DEFAULT NULL COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(32) NULL DEFAULT NULL COMMENT '更新人',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1406955981362733058, 0, '总部', '总部', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406957304434958338, 1406955981362733058, '科技公司', '科技有限公司', '0,1406955981362733058', '1', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406957570110562306, 1406957304434958338, '研发部', '研发部', '0,1406955981362733058,1406957304434958338', '2', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406957672636129281, 1406957304434958338, '测试部', '研发部', '0,1406955981362733058,1406957304434958338', '2', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dict_code` varchar(128) NULL DEFAULT NULL COMMENT '字典编码',
  `dict_name` varchar(128) NULL DEFAULT NULL COMMENT '字典名称',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `status` varchar(1) NULL DEFAULT '0' COMMENT '状态 0正常；1停用',
  `created_by` varchar(32) NULL DEFAULT NULL COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(32) NULL DEFAULT NULL COMMENT '更新人',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES (1401570456897892354, 'sys_del_flag', '删除标志', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1401572324235632642, 'sys_status', '状态', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406472890693287938, 'sys_menu_type', '菜单类型', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406473152816316418, 'sys_keepalive', '是否缓存', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406473209175179266, 'sys_link_external', '是否外链', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406473261809500161, 'sys_visible', '是否显示', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406473306558529537, 'sys_frame', '是否内嵌', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406950339923251201, 'sys_org_type', '机构类型', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407241433147891714, 'sys_data_scope', '数据范围', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407573521491406849, 'sys_sex', '性别', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407573902988521473, 'sys_lock_flag', '锁定标记', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1413871609639886850, 'sys_user_platform', '用户平台', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1414555294502830082, 'sys_log_status', '日志状态', NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_item`;
CREATE TABLE `sys_dict_item`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dict_id` bigint(20) NULL DEFAULT NULL COMMENT '字典ID',
  `dict_item_code` varchar(128) NULL DEFAULT NULL COMMENT '字典项编码',
  `dict_item_name` varchar(128) NULL DEFAULT NULL COMMENT '字典项名称',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `status` varchar(1) NULL DEFAULT '0' COMMENT '状态 0正常；1停用',
  `created_by` varchar(32) NULL DEFAULT NULL COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(32) NULL DEFAULT NULL COMMENT '更新人',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '字典项';

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_item` VALUES (1401571842909888513, 1401570456897892354, '0', '存在', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1401571885171695618, 1401570456897892354, '1', '删除', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1401583692674351106, 1401572324235632642, '0', '正常', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1401583809766735873, 1401572324235632642, '1', '停用', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406473608389033985, 1406472890693287938, 'dir', '目录', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406473679893528578, 1406472890693287938, 'menu', '菜单', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474042163953665, 1406472890693287938, 'button', '按钮', 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474046450532354, 1406473152816316418, '0', '缓存', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474049915027457, 1406473152816316418, '1', '不缓存', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474053656346626, 1406473209175179266, '0', '是', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474056919515137, 1406473209175179266, '1', '否', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474059859722241, 1406473261809500161, '0', '显示', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474062900592642, 1406473261809500161, '1', '隐藏', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474065467506690, 1406473306558529537, '0', '内嵌', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406474068839727105, 1406473306558529537, '1', '不内嵌', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406950411385802753, 1406950339923251201, '1', '公司', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406950452930383874, 1406950339923251201, '2', '部门', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406950491589283842, 1406950339923251201, '3', '小组', 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406950533255499778, 1406950339923251201, '4', '其他', 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407241507013779458, 1407241433147891714, '1', '全部数据权限', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407241563880153090, 1407241433147891714, '2', '自定义数据权限', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407241599363964930, 1407241433147891714, '3', '本部门数据权限', 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407241650542862337, 1407241433147891714, '4', '本部门及以下数据权限', 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407573651183480834, 1407573521491406849, '1', '男', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407573690739961857, 1407573521491406849, '2', '女', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407573740949975042, 1407573521491406849, '3', '未知', 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407573939994865665, 1407573902988521473, '0', '正常', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407574018822615041, 1407573902988521473, '1', '锁定', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1413871739889803266, 1413871609639886850, 'WEB', 'WEB管理后台', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1413871789256761345, 1413871609639886850, 'APP', '前端用户平台', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1414555512162041858, 1414555294502830082, '0', '成功', 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1414555546161070081, 1414555294502830082, '1', '失败', 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(128) NULL DEFAULT NULL COMMENT '标题',
  `log_status` varchar(1) NULL DEFAULT NULL COMMENT '日志状态 0成功；1失败',
  `user_platform` varchar(32) NULL DEFAULT NULL COMMENT '用户平台 WEB：WEB管理后台；APP：前端用户平台',
  `requset_uri` varchar(128) NULL DEFAULT NULL COMMENT '请求地址',
  `requset_type` varchar(128) NULL DEFAULT NULL COMMENT '请求方式',
  `requset_method` varchar(128) NULL DEFAULT NULL COMMENT '请求方法',
  `requset_params` text NULL COMMENT '请求参数',
  `response_result` text NULL COMMENT '返回参数',
  `requset_time` varchar(128) NULL DEFAULT NULL COMMENT '请求耗时',
  `exception` text NULL COMMENT '异常信息',
  `oper_name` varchar(128) NULL DEFAULT NULL COMMENT '操作人员',
  `ip_address` varchar(128) NULL DEFAULT NULL COMMENT 'IP地址',
  `oper_location` varchar(128) NULL DEFAULT NULL COMMENT '操作地点',
  `browser` varchar(128) NULL DEFAULT NULL COMMENT '浏览器类型',
  `os` varchar(128) NULL DEFAULT NULL COMMENT '操作系统',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '操作日志表 ';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `menu_type` varchar(32) NULL DEFAULT NULL COMMENT '菜单类型 dir目录；menu菜单；button按钮',
  `menu_name` varchar(128) NULL DEFAULT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '上级菜单',
  `route_path` varchar(512) NULL DEFAULT NULL COMMENT '路由地址',
  `component` varchar(512) NULL DEFAULT NULL COMMENT '组件路径',
  `permission` varchar(128) NULL DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(128) NULL DEFAULT NULL COMMENT '图标',
  `keepalive` varchar(1) NULL DEFAULT NULL COMMENT '是否缓存 0缓存；1不缓存',
  `link_external` varchar(1) NULL DEFAULT NULL COMMENT '是否外链 0是；1否',
  `visible` varchar(1) NULL DEFAULT NULL COMMENT '是否显示 0显示；1隐藏',
  `frame` varchar(1) NULL DEFAULT NULL COMMENT '是否内嵌 0内嵌；1不内嵌',
  `link_url` varchar(512) NULL DEFAULT NULL COMMENT '外部链接',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `status` varchar(1) NULL DEFAULT '0' COMMENT '状态 0正常；1停用',
  `created_by` varchar(32) NULL DEFAULT NULL COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(32) NULL DEFAULT NULL COMMENT '更新人',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '菜单表 ';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1406063931784179714, 'menu', '首页', 0, 'dashboard', '/dashboard/analysis/index', NULL, 'bx:bx-home', '0', '1', '0', NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1406064334403878913, 'dir', '系统管理', 0, 'system', NULL, NULL, 'ion:settings-outline', NULL, NULL, '0', NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847168, 'menu', '菜单管理', 1406064334403878913, 'sysMenu', '/system/sysMenu/index', NULL, 'ant-design:unordered-list-outlined', '0', '1', '0', NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847169, 'button', '菜单查询', 1411332040627847168, NULL, NULL, 'system:sysMenu:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847170, 'button', '菜单新增', 1411332040627847168, NULL, NULL, 'system:sysMenu:add', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847171, 'button', '菜单修改', 1411332040627847168, NULL, NULL, 'system:sysMenu:edit', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847172, 'button', '菜单删除', 1411332040627847168, NULL, NULL, 'system:sysMenu:remove', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847173, 'button', '菜单查看', 1411332040627847168, NULL, NULL, 'system:sysMenu:view', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847174, 'button', '菜单导出', 1411332040627847168, NULL, NULL, 'system:sysMenu:export', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847175, 'menu', '字典管理', 1406064334403878913, 'sysDict', '/system/sysDict/index', NULL, 'ant-design:translation-outlined', '0', '1', '0', NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847176, 'button', '字典查询', 1411332040627847175, NULL, NULL, 'system:sysDict:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847177, 'button', '字典新增', 1411332040627847175, NULL, NULL, 'system:sysDict:add', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847178, 'button', '字典修改', 1411332040627847175, NULL, NULL, 'system:sysDict:edit', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847179, 'button', '字典删除', 1411332040627847175, NULL, NULL, 'system:sysDict:remove', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847180, 'button', '字典查看', 1411332040627847175, NULL, NULL, 'system:sysDict:view', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847181, 'button', '字典导出', 1411332040627847175, NULL, NULL, 'system:sysDict:export', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847182, 'button', '字典刷新', 1411332040627847175, NULL, NULL, 'system:sysDict:refresh', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847183, 'button', '字典项查询', 1411332040627847175, NULL, NULL, 'system:sysDictItem:page', NULL, NULL, NULL, NULL, NULL, NULL, 7, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847184, 'button', '字典项新增', 1411332040627847175, NULL, NULL, 'system:sysDictItem:add', NULL, NULL, NULL, NULL, NULL, NULL, 8, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847185, 'button', '字典项修改', 1411332040627847175, NULL, NULL, 'system:sysDictItem:edit', NULL, NULL, NULL, NULL, NULL, NULL, 9, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847186, 'button', '字典项删除', 1411332040627847175, NULL, NULL, 'system:sysDictItem:remove', NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847187, 'button', '字典项查看', 1411332040627847175, NULL, NULL, 'system:sysDictItem:view', NULL, NULL, NULL, NULL, NULL, NULL, 11, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847188, 'button', '字典项导出', 1411332040627847175, NULL, NULL, 'system:sysDictItem:export', NULL, NULL, NULL, NULL, NULL, NULL, 12, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847189, 'menu', '部门管理', 1406064334403878913, 'sysDept', '/system/sysDept/index', NULL, 'ant-design:cluster-outlined', '0', '1', '0', NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847190, 'button', '部门查询', 1411332040627847189, NULL, NULL, 'system:sysDept:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847191, 'button', '部门新增', 1411332040627847189, NULL, NULL, 'system:sysDept:add', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847192, 'button', '部门修改', 1411332040627847189, NULL, NULL, 'system:sysDept:edit', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847193, 'button', '部门删除', 1411332040627847189, NULL, NULL, 'system:sysDept:remove', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847194, 'button', '部门查看', 1411332040627847189, NULL, NULL, 'system:sysDept:view', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040627847195, 'button', '部门导出', 1411332040627847189, NULL, NULL, 'system:sysDept:export', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790208, 'menu', '岗位管理', 1406064334403878913, 'sysPost', '/system/sysPost/index', NULL, 'ant-design:idcard-outlined', '0', '1', '0', NULL, NULL, 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790209, 'button', '岗位查询', 1411332040669790208, NULL, NULL, 'system:sysPost:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790210, 'button', '岗位新增', 1411332040669790208, NULL, NULL, 'system:sysPost:add', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790211, 'button', '岗位修改', 1411332040669790208, NULL, NULL, 'system:sysPost:edit', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790212, 'button', '岗位删除', 1411332040669790208, NULL, NULL, 'system:sysPost:remove', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790213, 'button', '岗位查看', 1411332040669790208, NULL, NULL, 'system:sysPost:view', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790214, 'button', '岗位导出', 1411332040669790208, NULL, NULL, 'system:sysPost:export', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790215, 'menu', '角色管理', 1406064334403878913, 'sysRole', '/system/sysRole/index', NULL, 'ant-design:team-outlined', '0', '1', '0', NULL, NULL, 5, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790216, 'button', '角色查询', 1411332040669790215, NULL, NULL, 'system:sysRole:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790217, 'button', '角色新增', 1411332040669790215, NULL, NULL, 'system:sysRole:add', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790218, 'button', '角色修改', 1411332040669790215, NULL, NULL, 'system:sysRole:edit', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790219, 'button', '角色删除', 1411332040669790215, NULL, NULL, 'system:sysRole:remove', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790220, 'button', '角色查看', 1411332040669790215, NULL, NULL, 'system:sysRole:view', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790221, 'button', '角色导出', 1411332040669790215, NULL, NULL, 'system:sysRole:export', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790222, 'menu', '用户管理', 1406064334403878913, 'sysUser', '/system/sysUser/index', NULL, 'ant-design:user-outlined', '0', '1', '0', NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790223, 'button', '用户查询', 1411332040669790222, NULL, NULL, 'system:sysUser:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790224, 'button', '用户新增', 1411332040669790222, NULL, NULL, 'system:sysUser:add', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790225, 'button', '用户修改', 1411332040669790222, NULL, NULL, 'system:sysUser:edit', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790226, 'button', '用户删除', 1411332040669790222, NULL, NULL, 'system:sysUser:remove', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790227, 'button', '用户查看', 1411332040669790222, NULL, NULL, 'system:sysUser:view', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790228, 'button', '用户导出', 1411332040669790222, NULL, NULL, 'system:sysUser:export', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790229, 'menu', '参数管理', 1406064334403878913, 'sysConfig', '/system/sysConfig/index', NULL, 'ant-design:tool-outlined', '0', '1', '0', NULL, NULL, 7, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790230, 'button', '参数查询', 1411332040669790229, NULL, NULL, 'system:sysConfig:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790231, 'button', '参数新增', 1411332040669790229, NULL, NULL, 'system:sysConfig:add', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790232, 'button', '参数修改', 1411332040669790229, NULL, NULL, 'system:sysConfig:edit', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790233, 'button', '参数删除', 1411332040669790229, NULL, NULL, 'system:sysConfig:remove', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790234, 'button', '参数查看', 1411332040669790229, NULL, NULL, 'system:sysConfig:view', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1411332040669790235, 'button', '参数导出', 1411332040669790229, NULL, NULL, 'system:sysConfig:export', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1413135668142997506, 'button', '参数刷新', 1411332040669790229, NULL, NULL, 'system:sysConfig:refresh', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1413861880461025281, 'dir', '系统监控', 0, 'monitor', NULL, NULL, 'ant-design:fund-projection-screen-outlined', NULL, NULL, '0', NULL, NULL, 3, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1413862976243916802, 'menu', '在线用户', 1413861880461025281, 'onlineUser', '/monitor/onlineUser/index', NULL, 'ant-design:user-outlined', '0', '1', '0', NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1413875787581906945, 'button', '在线用户查询', 1413862976243916802, NULL, NULL, 'monitor:online:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1413875937951899650, 'button', '在线用户强退', 1413862976243916802, NULL, NULL, 'monitor:online:forceLogout', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1414510956372819968, 'menu', '操作日志', 1413861880461025281, 'sysLog', '/system/sysLog/index', NULL, 'ant-design:file-search-outlined', '0', '1', '0', NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1414510956372819969, 'button', '操作日志查询', 1414510956372819968, NULL, NULL, 'system:sysLog:page', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1414510956372819973, 'button', '操作日志查看', 1414510956372819968, NULL, NULL, 'system:sysLog:view', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `post_code` varchar(128) NULL DEFAULT NULL COMMENT '岗位编码',
  `post_name` varchar(128) NULL DEFAULT NULL COMMENT '岗位名称',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `status` varchar(1) NULL DEFAULT '0' COMMENT '状态 0正常；1停用',
  `created_by` varchar(32) NULL DEFAULT NULL COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(32) NULL DEFAULT NULL COMMENT '更新人',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '岗位表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` VALUES (1407219533063471106, '000001', '董事长', NULL, 1, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00'), (1407222184903786498, '000002', '普通员工', NULL, 2, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_code` varchar(128) NULL DEFAULT NULL COMMENT '角色编码',
  `role_name` varchar(128) NULL DEFAULT NULL COMMENT '角色名称',
  `data_scope` varchar(1) NULL DEFAULT NULL COMMENT '数据范围 1全部数据权限；2自定义数据权限；3本部门数据权限；4本部门及以下数据权限',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `status` varchar(1) NULL DEFAULT '0' COMMENT '状态 0正常；1停用',
  `created_by` varchar(32) NULL DEFAULT NULL COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(32) NULL DEFAULT NULL COMMENT '更新人',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1401043545271136258, 'admin', '超级管理员', '1', NULL, 1, '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '角色部门表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '角色菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `account` varchar(128) NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(128) NULL DEFAULT NULL COMMENT '密码',
  `psw_modified` varchar(1) NULL DEFAULT NULL COMMENT '修改密码标记 0未修改；1已修改',
  `nickname` varchar(128) NULL DEFAULT NULL COMMENT '昵称',
  `realname` varchar(128) NULL DEFAULT NULL COMMENT '姓名',
  `english_name` varchar(128) NULL DEFAULT NULL COMMENT '英文名',
  `avatar` varchar(128) NULL DEFAULT NULL COMMENT '头像',
  `email` varchar(128) NULL DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(32) NULL DEFAULT NULL COMMENT '手机号',
  `staff_number` varchar(32) NULL DEFAULT NULL COMMENT '工号',
  `birthday` datetime(0) NULL DEFAULT NULL COMMENT '生日',
  `sex` varchar(1) NULL DEFAULT NULL COMMENT '性别 1男；2女；3未知',
  `dept_id` varchar(32) NULL DEFAULT NULL COMMENT '部门ID',
  `lock_flag` varchar(1) NULL DEFAULT NULL COMMENT '锁定标记 0正常；1锁定',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `remarks` varchar(512) NULL DEFAULT NULL COMMENT '备注',
  `status` varchar(1) NULL DEFAULT '0' COMMENT '状态 0正常；1停用',
  `del_flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记 0存在；1删除',
  `created_by` varchar(32) NULL DEFAULT NULL COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(32) NULL DEFAULT NULL COMMENT '更新人',
  `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1401043674048851970, 'admin', '$2a$10$48YWX5OP2DHDsycHCGSskuUw9hBjuh7fZTkH.QdJnwQb0Ze9mJm3i', '1', '超级管理员', '超级管理员', 'admin', NULL, NULL, '18888888888', NULL, NULL, '1', '1406955981362733058', '0', 1, NULL, '0', '0', '1401043674048851970', '2022-07-01 00:00:00', '1401043674048851970', '2022-07-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
  `post_id` bigint(20) NULL DEFAULT NULL COMMENT '岗位ID',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '用户岗位表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_post` VALUES (1411902133752573954, 1401043674048851970, 1407219533063471106);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户编号',
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色编号',
  PRIMARY KEY (`id`) USING BTREE
) COMMENT = '用户角色表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1411902133966483458, 1401043674048851970, 1401043545271136258);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
